{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["README"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[45,10,50,17],[35,10,37,16],[3,1,3,2],[0,1,2,6],[3,4,3,5],[16,1,18,7],[20,1,22,7],[24,1,25,7],[27,1,29,7],[31,10,33,16]]}
[null,"Cytology Analysis Report"]
[]
[null,null,null,null,null,null,null,null,null,null,"Information"]
[null,"Recall Search Date Range",null,null,"Age range in Years",null,null,null,null,null,"This report will import all OUTSTANDING cytology recalls from START date"]
[null,"START","END",null,"From","To",null,null,null,null,"Only female patients with an active registration status and defined age range"]
[null,"2016-03-01",null,null,25,64,null,null,null,null,"The \"From\" Age is calculated from the Start date, while \"To\" age is from today"]
[]
[null,"You must be signed into Vision to compile the data",null,null,null,null,null,null,null,null,"Colposcopy Read Codes in last year (All Clinical & Problems) in age range"]
[null,"This workbook will minimise while compiling and maximise when complete",null,null,null,null,null,null,null,null,"36143%","Colposcopy normal"]
[null,null,null,null,null,null,null,null,null,null,"36154%","Colposcopy abnormal"]
[null,"CXPATS spreadsheet",null,null,null,null,null,null,null,null,"7D1C2%","Colposcopy NEC"]
[null,"This is the master sheet and displays the last cytology recall (after start date)",null,null,null,null,null,null,null,null,"7D1C3%","Colposcopy of vagina"]
[null,"If no recall exists after start date \"NO_RECALL\" is shown in red",null,null,null,null,null,null,null,null,"7E034%","Colposcopy of cervix"]
[null,"Recall dates show in Red on Yellow are before today (i.e. need updating)",null,null,null,null,null,null,null,null,"8H7N%","Refer for colposcopy (& Referral Entity)"]
[null,null,null,null,null,null,null,null,null,null,"9N1e%","Seen in colposcopy clinic"]
[null,"It also displays the last cytology result or NO_RESULT if not found",null,null,null,null,null,null,null,null,"9NiW%","Did not attend colposcopy clinic"]
[null,"The last cytology result is determined using a sort of PAT_ID, Performed date and an algorithm on the Read code to try and get the 4K2 numbers to show before the 4K2 letters and 685 codes as these are the actual results"]
[null,null,null,null,null,null,null,null,null,null,"Hysterectomy Read  Codes Ever (All Clinical & Problems) in age range"]
[null,null,null,null,null,null,null,null,null,null,"7E04%","Abdominal excision of uterus"]
[null,null,null,null,null,null,null,null,null,null,"7E05%","Vaginal excision of uterus"]
[null,"Hysterectomy patients NOT excluded from target report are shown in red background across the row. If hysterectomy date is after the last cytology result date the hysterectomy date is also displayed in red text on pink background"]
[null,null,null,null,null,null,null,null,null,null,"Cytology Recall Read Codes"]
[null,null,null,null,null,null,null,null,null,null,"685%","Cervical neoplasia screening"]
[null,null,null,null,null,null,null,null,null,null,"4K2%","Cervical smear result"]
[null,"It will automatially remove all patients where the LAST result is \"Exclude from target report\" = YES for whatever reason",null,null,null,null,null,null,null,null,"4K3%","Cervical smear - inflam. Change"]
[null,null,null,null,null,null,null,null,null,null,"4K4%","Cervical smear - action needed"]
[null,null,null,null,null,null,null,null,null,null,"4K5%","Cytology - general"]
[null,"The purpose of this sheet is to show patients with no recall (who should have one set in the future)  and to remove patients that do not need recalling by setting  \"Exclude from target report\", to leave an active recall list",null,null,null,null,null,null,null,null,"4KA%","Vaginal vault smear result"]
[null,null,null,null,null,null,null,null,null,null,"4KK%","Vaginal vault smear action needed"]
[null,null,null,null,null,null,null,null,null,null,"9O8%","Cervical smear screen admin"]
[]
[null,"Use the Patient Group Import App under the Vision Apps Controller > System Utilities",null,null,null,null,null,null,null,null,"The SMEAR sheets looks of all Read codes (shown above) in a medical history or 4K3%, 4K4%, 4K5%, 4KK% in a test result in last 10 years for those in set age range"]
[null,"To import any patients from this workbook back into Vision Patient Groups"]
[null,"Just save the PAT_IDs from this workbook in a CSV file"]
[]
[null,"View the Vision Help file (link below) for  Patient Group Import App\n",null,null,null,null,null,null,null,null,"The CYTOLOGY sheet shows all cytology results EVER (using data from the cytology entity only) for those in set age range"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"The EDD sheet determines pregnancy by:"]
[null,"NOTE:",null,null,null,null,null,null,null,null,"1. The LMP date must be after Outcome date (Outcome data is clear if not)"]
[null,"This will only work if Vision is on DLM485 or above.",null,null,null,null,null,null,null,null,"2. If there is an Outcome patient is no longer pregnant"]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed",null,null,null,null,null,null,null,null,"3. If Outcome is blank patient is pregnant"]
[]
[null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[null,null,null,null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[]
[null,"Current Version: 1.1"]
[null,"Last updated: 08/03/2016"]
[null,"Written by: Bradley Sieve"]
[null,"Email: "]